Can't find Confirm Action Queries in View menu, options due to moved to Tools.
Cause:
The 'Options...' command has been moved to the 'Tools' menu, and the 'Confirm Action Queries' option has been renamed 'Action Queries' and moved to the 'Confirm' group of the 'Edit/Find' tab.
Solution:
To enable the confirmation of action queries in Access 7.0, use the 'Options...' command under the 'Tools' menu, and select the 'Action Queries' check box in the 'Confirm' group of the 'Edit/Find' tab.
1) Select the 'Tools' menu and select 'Options...'. (The Options dialog box appears.)
2) Click the 'Edit/Find' tab.
3) Select the 'Action Queries' check box in the 'Confirm' group.
NOTE: Checking 'Action Queries' sets the confirmation for action queries as the default for all new queries.
Action Queries
4) Click 'OK'. (The Options dialog box closes. From now on, a confirmation message will appear whenever an action query is run.)